SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310319 LIMIT 1 [ RunTime:0.004000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310319 [ RunTime:0.004029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644527,656669,729620,964649,725332,467287,939485,6349,797396,34550,465720,218007,296364,568917,747322,92363,123651,468293,82177,855060,350464,712736,446449,228964,514462,809686,914082,1046528,310345,60731,82221,804218,312599,941913,65013,250061,744787,868323,969925,650981,283736,970426,1004016,685199,61956,890586,39410,265401,121804,982586,706064,801125,450208,798563,771643,271051,420207,578862,511377,354944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]