SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406746 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406746 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720093,616147,488734,546309,367627,373026,978518,850460,959917,378832,133057,163160,320496,503137,861321,765161,576392,909205,75424,462372,638419,594222,986998,404583,156594,930434,379141,367034,1007162,738252,942991,970973,247561,615101,309909,317134,93966,504041,426427,423327,525400,30922,651036,535171,670847,388669,477771,828922,878838,467657,987746,122377,570100,502520,836091,326247,965749,371738,240182,991158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002040s ]