SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332691 LIMIT 1 [ RunTime:0.000893s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332691 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179312,540544,415238,1031487,468655,310973,247155,39549,925072,413229,652420,947661,597384,497127,162934,92254,40246,303124,512876,28200,580341,204294,880420,582734,742624,493213,926940,543117,902795,436145,161304,27925,332468,906530,856056,120558,319916,1012326,768912,1036159,1044462,881921,644625,1000919,595242,887547,116864,882967,564412,877740,600377,882514,892916,706657,303043,894522,482220,166375,477723,412907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003034s ]