SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42641 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42641 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95494,851805,859337,901152,19102,451936,794020,497572,701347,326534,258314,969066,812478,387308,273189,700511,683658,165541,736702,378738,686237,264486,424020,471605,372877,74964,110514,23583,611219,367275,506893,885206,800967,724616,11005,425803,1020661,289169,609093,697035,701848,837950,1014765,350700,294351,1023766,60115,850686,120351,848936,881054,1019888,52576,686100,932468,805297,227743,496674,201157,326643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]