SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284512 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284512 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471302,492786,680195,535252,164767,1012275,102248,155178,565402,659541,759031,279259,1013052,999878,794508,339029,348838,374108,739857,558320,357300,152268,406652,975384,472012,555014,418839,404881,309777,523694,915404,440515,695512,103477,203268,222019,742375,743576,309568,703409,366891,956289,234966,158882,359599,1034097,284504,929986,746353,941110,346706,698095,461727,521267,961114,951507,576342,778338,1010955,566759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]