SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301114 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301114 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41574,243011,592991,953993,266897,76772,369028,259192,844807,570037,251829,261652,815082,567496,447893,254221,8927,591815,1012799,394537,519887,550782,58763,709682,536858,734234,359225,231562,701965,114080,1047876,866448,749803,333624,882463,56721,989655,845668,8090,674361,236976,440168,772509,441365,440663,509517,160851,525585,1021619,464005,371387,928999,354912,860787,230520,196898,470274,887786,565280,680469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]