SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305106 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305106 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115656,324909,400169,879591,39140,111409,489191,481802,296406,127896,579839,299206,813084,403391,583315,1039193,971682,1016871,113810,364740,616906,298867,946517,345344,646538,900469,71969,437434,676501,869736,64882,853892,825353,1042445,606969,590271,112911,316113,819385,1003739,511513,29831,637811,368828,732768,1025500,456970,991946,656891,27851,1031858,411564,818836,703793,618349,64491,803631,461182,531799,583007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]