SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100429 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100429 [ RunTime:0.003826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343918,511890,400984,441984,694551,464645,806188,609473,558417,966890,132235,626056,702555,997967,975979,427157,966113,22702,53749,403762,539501,472093,299552,365756,1033184,206538,366345,412468,271582,106942,694326,61447,249912,994698,996094,919152,991762,471557,471661,10304,1009617,460047,565336,981036,301235,13177,271672,727575,612865,952539,52703,772168,430791,683326,706976,120092,436678,258568,1001337,1009298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]