SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328189 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328189 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787513,33359,60242,746254,197825,680150,979541,250685,766804,839254,219892,485572,58997,643972,81839,17976,388117,1045597,935143,698162,674393,1003620,172664,559880,52774,739267,199724,400223,86609,438182,428314,647246,190488,197674,866278,489851,506599,38873,639259,270071,551093,833133,253764,398054,429311,35727,988730,301303,124809,313116,497949,955157,895960,348185,641503,897368,564915,785753,930958,234668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]