SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 817610 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 817610 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502901,27155,177256,13832,789411,402484,881798,199269,556966,84406,1039317,286411,549647,14939,458171,932407,735898,708985,619464,136798,190013,48477,35978,324002,632351,936433,597154,278627,48501,793588,411846,777589,348241,953826,340203,200925,176395,130248,715196,402968,444548,677394,671270,561729,193815,592649,111881,185608,824689,469622,1012846,864403,710261,336961,742097,87320,838893,516804,597573,980533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 817610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 817610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]