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` = 1043003 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043003 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851586,789204,663156,839036,353250,877467,182325,215517,893187,163568,444844,936856,920889,509187,512322,344680,638051,334591,382276,836087,870867,341048,79741,480600,865696,160057,428370,1040271,904130,25721,267550,406144,39957,380341,152381,438982,197236,1044814,306109,700414,556429,764239,72912,948551,711092,856920,1043254,371261,579828,992863,1001836,486008,408874,25543,277213,13823,178622,789292,819332,597816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]