SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002644s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100056 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100056 [ RunTime:0.002462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424449,1026486,696628,620920,470369,716507,370157,237943,1033871,195700,679095,323095,407449,688369,396709,294357,399635,937088,447006,880941,56649,362057,885849,632148,673048,630982,870847,932203,801567,130941,687940,1015895,197394,415077,698666,391274,277432,262459,157386,1023896,14708,1046550,619351,963178,649098,111678,490602,530427,634477,296965,515377,435960,942115,298188,556795,907997,198864,373444,927999,256540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]