SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406226 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406226 [ RunTime:0.004743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021681,952536,785075,488596,586027,1043815,921113,268755,958586,820367,3451,217268,779750,51045,765246,279775,840782,1023388,915066,59291,378046,924979,809863,444002,32437,754955,266500,326465,991386,408982,410770,402984,360822,988931,40772,808622,471173,470998,695397,774725,103806,79711,536377,578514,372265,198321,63605,533712,909798,918583,825731,450292,852667,728434,472419,530782,737163,317927,456797,995018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]