SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 222018 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 222018 [ RunTime:0.001431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535910,309802,426434,881995,562175,377601,501323,460013,467632,388714,168406,1022437,76966,212591,163535,899838,233113,376318,29863,600511,818691,742755,898449,931182,667093,632512,42903,405830,539294,135212,698653,284525,801034,577049,880130,824120,87703,221992,531833,43784,312345,766509,649892,303329,745762,942976,896435,893517,138613,296886,338494,949041,233141,272428,14194,363748,496479,345919,532673,846512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 222018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 222018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001667s ]