SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194901 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194901 [ RunTime:0.002621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306206,801216,443570,362803,310487,403162,688578,702327,672453,705684,250177,888484,1048291,695554,320765,869668,83783,611167,541861,643453,737990,1000165,833447,753152,271529,714318,305193,326473,851802,167940,280766,210083,812853,52819,907281,165181,316504,354582,612315,373531,705139,42847,329193,25950,591429,291217,294802,896230,373896,94841,653666,827087,668415,837679,964701,638568,448387,295096,829364,698124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]