SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346818 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346818 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21820,1025142,436781,295421,332475,604347,1037249,74198,401541,188606,147664,815582,249728,622698,465173,589057,21618,345200,801912,785616,511049,907776,213910,684513,518226,353828,444110,367554,843067,832517,483447,39378,609219,232774,711767,869020,718061,201264,122183,664559,422258,949922,642154,700739,821989,195003,664713,266927,660181,580862,688714,214454,778192,262721,659183,1032583,158283,321410,649490,88964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000895s ]