SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34658 LIMIT 1 [ RunTime:0.001965s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34658 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140043,547532,907768,453087,213569,136371,751158,658993,10197,901018,652649,989350,407445,486598,531722,853663,625964,744055,615917,296908,594939,487430,991462,784171,733899,917259,907288,460720,586224,521872,253494,906349,808614,293584,81473,841875,756482,118228,792669,996476,685785,271372,292308,457986,855696,941508,924083,362290,484329,145462,460348,580210,24202,655101,484735,727571,65290,400215,646454,384546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]