SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154834 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154834 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101278,461187,915468,524632,465532,27301,807567,425946,578575,675527,371137,978977,900349,991881,53555,420932,676263,1036250,871188,9800,555761,104729,582773,222127,17161,337770,193632,1043984,704740,795891,654947,85708,243058,1000722,51655,747728,800797,117707,235551,196360,280112,1014158,522994,134232,458258,814203,634420,252390,593096,972888,64761,530049,576764,634439,29941,739668,385590,624503,975513,229861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001033s ]