SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002873 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002873 [ RunTime:0.002946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514694,134868,948188,269472,1009163,403455,114766,490179,121606,356270,406493,670940,845661,798602,615077,1048281,215450,843511,964426,18355,942062,699169,90781,816642,1023230,712327,364267,654914,306943,829820,683396,361633,337600,244454,791366,640829,649672,485458,548668,633742,404941,427429,89749,944554,10963,595494,948717,708936,111323,205859,854599,718762,841884,381202,229849,518581,678921,406978,575682,869108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002030s ]