SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505700 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505700 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879488,289447,414982,499695,929122,700778,493684,1004079,637626,498880,836775,998678,28084,319683,260823,712204,827146,580863,733143,105278,77105,896445,147162,597945,791721,756553,1023144,98873,554154,684601,662796,35092,754034,123663,297936,503626,566521,1046160,334971,371168,821337,924138,874594,327228,803084,882977,583678,954778,619339,124085,699301,1045398,503136,531921,238892,859690,1040301,331691,914868,360921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001944s ]