SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302118 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302118 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114041,510315,798714,955251,631273,247217,459842,420750,988890,287669,17789,602745,743214,1006804,587182,987359,1014100,371724,436110,862494,805644,828883,540251,157686,170726,16162,408177,570852,898605,662528,358737,253617,102317,687699,905698,273823,188860,394667,232899,618292,203224,915897,793961,824362,595726,152420,302741,378836,458711,640595,658084,596955,701740,26473,657485,985836,777010,483373,869589,208021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]