SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417890 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417890 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144697,977393,273521,138716,66098,256640,535579,490193,926657,991540,365012,469660,288764,622061,567972,874843,672020,453184,873377,428606,346320,58162,180984,837916,674767,209566,815788,101215,483180,264316,61923,149967,788734,883846,287829,45132,772185,116194,100252,935199,27456,139801,918210,873859,577902,267278,370371,14219,428716,682565,1032917,839587,759890,311941,527244,486561,719503,955858,680655,16931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]