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` = 580450 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580450 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309605,687901,741874,459678,946089,370007,914134,464693,780628,1032845,511478,351485,506593,509441,378428,442341,871346,912994,430915,797591,58243,215441,113788,130928,1246,479787,141466,262826,849981,14322,671158,84588,959622,866978,53249,212942,758287,677390,446062,981450,415253,754678,679260,835345,315888,713096,327961,827027,975421,496826,821956,913029,311895,313124,864698,675962,280997,287753,788219,281652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]