SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511738 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511738 [ RunTime:0.003330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150062,155143,57517,1021861,883791,630482,1026740,681928,910656,659940,797482,983987,258828,572128,660606,228849,591998,428130,289730,800516,735164,240137,75807,302390,354832,552501,956513,215470,217105,203806,920596,603786,684590,203899,900130,661989,101629,782468,79066,958281,717219,945758,819553,1019953,666454,912328,711225,718426,1045179,675998,884164,205364,630471,444013,175713,207443,626708,298047,746288,422714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]