SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408051 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408051 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425233,709957,203674,244456,582169,630384,163354,825782,625271,1016238,639854,666811,923988,572688,338216,112665,19460,516509,718688,322663,693152,594727,401419,674428,80475,637822,863628,675364,820750,1019921,181772,110321,147145,863327,975726,187868,328630,716560,600406,76023,132586,289272,222348,1000069,354278,561533,729299,766494,111758,486023,19768,513037,480896,213772,461518,962578,118685,128320,153425,779425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004087s ]