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` = 586306 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586306 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171828,913191,488675,1015068,742738,761881,233205,437015,365981,558048,280152,320673,755656,239606,647741,689791,782692,521519,257785,973030,1006908,1022069,85058,801243,957540,255592,477083,232860,454031,90914,453944,712461,790736,485961,202912,1000345,25097,135567,383131,21139,119012,408742,702071,312043,669409,215768,514819,336854,793920,535091,419621,94956,850147,803675,711023,799787,508336,799926,1003112,841731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]