SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330934 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330934 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291871,748210,336781,71929,684573,566686,286792,538356,642679,916083,998355,583261,710033,518858,856697,765691,497827,269589,441271,309456,1038733,58676,720710,110796,840684,428104,844826,318289,929717,10586,958011,705906,733824,430398,351267,234764,804086,671122,641854,106912,197720,535744,874942,717617,221840,1037140,904269,837934,1015213,402983,107632,569797,764801,868812,793102,309584,331068,402729,688459,882996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]