SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269541 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269541 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357182,1025754,1017341,864221,626585,1025877,287241,642793,23929,255226,160379,401071,208991,195248,87209,44124,972184,676945,831547,57202,643230,988893,816215,892328,512773,928295,80912,980559,304892,747934,80436,143997,971161,578009,676871,19825,848563,124132,554469,1023770,754092,419160,803551,663262,574358,603749,439162,713752,611716,153825,126934,618965,555923,383969,6884,631789,298490,609790,509542,837932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]