SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 744218 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 744218 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044190,109600,508272,477795,314186,788834,857340,90347,938373,674263,642022,177798,790704,254360,340181,525814,339877,1004167,594931,169696,877804,80615,41064,327314,44286,113873,803175,662254,736263,99917,999220,659704,756304,537185,736695,1009547,67458,824366,802252,15285,178329,724106,146249,615186,262267,553379,10606,813719,771405,487187,377447,715866,8165,638169,152705,95736,1003198,215416,172169,307161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 744218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 744218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]