SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414693 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414693 [ RunTime:0.002415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544323,927675,711990,195012,101214,21556,493554,556806,813707,103739,166061,725157,29524,747021,63906,146835,304188,216475,71862,390569,749748,442523,644434,953801,761969,863412,912928,199978,722118,7585,198194,514572,444386,676553,795665,1038916,887222,635689,476846,194322,756055,54872,282152,683167,647730,846969,397572,417268,632249,336236,658787,1012896,35911,183488,247199,571015,52395,942789,702213,765463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]