SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 288526 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 288526 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022100,975910,358360,498609,1030639,341179,848300,108203,976559,105155,910793,1005070,585587,837531,63570,843914,518747,1023580,151593,614420,16052,227384,197412,592314,294429,362291,768047,218513,899711,456937,569280,385928,451169,468250,244575,79771,444244,670570,650263,559612,1018272,414486,282349,600344,963436,677935,752335,812675,297424,75877,399413,596026,913702,572711,112156,567655,137163,591808,1031523,643235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 288526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 288526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]