SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333957 LIMIT 1 [ RunTime:0.001490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333957 [ RunTime:0.003273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652928,306669,188312,76740,657225,330324,671556,933042,842179,117369,511238,261579,939604,919058,794674,790972,194363,589012,438987,588846,118090,810633,502922,829614,96660,90223,556023,802271,571857,959311,522990,1021988,907642,759323,285126,222523,427920,207312,383557,874318,986704,494928,688719,785671,705054,616838,999879,72249,45180,723315,904360,716115,21945,1019099,48521,756071,332590,111929,787211,606591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]