SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019347 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019347 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36826,1018780,879687,999896,894306,430380,542343,754945,408878,242605,816231,682753,925477,480744,1000412,802740,47806,929803,369160,667007,642743,134713,246327,187285,92667,850179,847535,441400,839469,552773,362452,238425,283595,450457,672513,775646,587815,859075,541051,317011,937468,1048661,816273,401513,902407,729028,740271,802549,767703,871013,62754,914594,1372,366242,378481,201367,138027,207325,142330,727185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019347 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019347 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]