SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42748 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42748 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3628,490706,181595,135030,646849,479675,534090,551602,366882,391397,998380,420486,473498,782317,911088,169301,583300,446665,573858,996267,683654,491052,135150,282553,48088,631895,483450,6204,118295,481414,552331,75369,547271,388615,564582,862339,877056,263136,584178,771334,394174,833969,337995,974210,406802,3609,741818,80076,33602,771290,907944,285814,744928,258996,547866,365016,773052,458402,319965,75974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]