SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569051 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569051 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40390,453427,718576,575991,317487,485933,194442,632131,453385,51415,688898,423451,24228,225701,688649,146742,572039,890937,1039876,71372,461068,960379,748038,840876,252302,634280,645348,776874,399163,144797,314495,458055,931718,30468,1009562,30100,922902,31060,353197,385216,224790,597595,111989,898123,391753,806018,101855,682519,371705,580377,991004,117913,559247,1046195,669299,972851,186471,842000,22040,624144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]