SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 692481 LIMIT 1 [ RunTime:0.001141s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 692481 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6093,553440,1041905,280438,394685,849267,196931,432656,1011334,727240,796203,597361,250933,635541,618143,814497,19063,168987,403560,120166,725041,127765,222964,237898,1017072,899962,155445,75742,408045,11666,360014,521815,223918,41345,354876,416080,580349,643829,945640,193670,1000111,826074,182025,540059,865074,112072,1046034,470005,357215,245530,436366,780091,385836,147557,442828,851433,640393,382776,394691,868578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 692481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 692481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002970s ]