SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461099 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461099 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405450,912686,929472,510967,337122,541026,937693,703660,91689,228197,666364,281548,525220,246618,875338,949422,390714,415863,708329,512673,939116,771305,782832,936807,1036273,4109,959176,697684,100571,748641,540512,413618,242541,321067,161679,254679,1039111,492772,185278,207677,134847,775518,827464,915405,710932,221963,149230,171734,440120,886321,145663,376864,404756,550991,13254,251051,511876,720600,449826,990370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]