SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004778s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267589 LIMIT 1 [ RunTime:0.002160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267589 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583300,875131,228163,323624,748995,703104,544617,441757,17558,588810,1045239,889642,1028439,692263,988285,763113,203937,829073,86584,749653,316411,871043,651655,882577,37887,266627,167325,293226,341015,57640,808730,928990,68163,264474,294108,774784,908787,957114,258950,653565,732277,35391,205757,1013880,866774,434916,554635,979748,287572,105390,943352,391889,205696,21476,936630,896960,75227,845557,294958,344561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]