SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345630 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345630 [ RunTime:0.004958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619117,1016948,488955,646880,274142,326354,259454,490367,230183,928617,158732,396344,527558,9831,599947,812637,892273,844784,295564,912792,601936,280596,168105,708800,812785,275493,484586,435199,132697,38920,622574,436056,655719,1018532,267879,494620,685195,169271,852578,568062,509660,186626,367197,856334,66542,305800,820898,317693,527787,573306,603287,835080,881929,528910,160534,10584,770092,827618,223344,245475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]