SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426028 LIMIT 1 [ RunTime:0.000910s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426028 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953660,516926,83142,231257,940088,1014368,807724,891034,923865,888959,520085,539734,959833,690718,990978,1041993,427801,500221,828876,351414,881232,1047103,94534,864933,455629,6725,602545,829559,223801,624819,659648,86363,649072,797410,893055,995581,208949,224523,492683,962720,753099,973557,782777,292461,949535,1022623,271636,774818,797644,988674,644198,153815,458608,138980,251649,124519,210347,201357,913416,210986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]