SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566591 LIMIT 1 [ RunTime:0.001962s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566591 [ RunTime:0.006471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71349,616284,80536,262696,509149,668447,683518,440761,498162,245303,938186,852730,276742,816716,223490,425238,1001311,409629,443530,299585,14967,266674,321852,707606,205726,160611,255394,47789,95924,110110,694082,853877,297918,883629,737497,472510,412215,679320,126323,44347,110527,567883,809567,396450,742145,106924,903615,501729,19985,676990,481651,243937,90507,765867,189786,585384,374984,711001,331205,346579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002457s ]