SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310040 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310040 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772758,853482,58912,294825,227693,676506,490789,957529,134240,214064,1039156,34127,1000409,492434,865163,234560,103605,772683,819146,659969,772576,856733,91127,918066,843230,409517,512193,936710,149079,641212,826726,559697,942671,335656,1012488,730315,645385,30764,846403,886069,554762,189632,45467,488882,933052,268049,482037,907792,364770,269954,923743,1018523,219482,69274,361988,831347,974130,991678,417382,584024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002358s ]