SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020986 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020986 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862165,918145,337401,521121,513836,742142,685970,445967,439238,739976,700445,897741,109097,1022147,149990,351665,263372,1002823,328580,423568,7414,346639,999861,269680,137627,813399,108321,227535,705810,368396,496336,923207,21975,686498,952020,607029,400478,141180,899219,747218,1012720,556127,481371,477472,834985,586856,723957,232448,741151,585868,128054,305681,1031604,169447,668398,899657,255589,968452,844596,74158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]