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` = 1037136 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037136 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31589,297132,253297,651371,423472,82439,1013070,187438,873273,703792,76469,166445,995844,995684,865510,39326,941580,720389,294789,525484,696162,554690,825865,47501,1039347,957207,894904,971839,799727,553632,97832,580804,274343,29428,532872,946586,1008933,164769,189772,314974,896625,277505,64204,115721,338315,475392,335179,831133,134132,206630,35678,525015,932909,639481,42465,797163,524233,849319,999063,481753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]