SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001934s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501631 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501631 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918320,406451,378900,813892,393519,384813,236213,72528,881165,837807,467730,27097,736227,315001,923822,41240,116556,903416,885917,944423,213935,855845,127494,122769,470851,401727,876984,622792,12123,1024027,903672,525088,640957,721064,1029372,294102,543205,246523,659098,806213,28702,179612,931871,819140,578928,862112,392216,253019,135793,391089,720858,688262,355596,242888,814045,959729,750596,170967,522037,821993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]