SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711020 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711020 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046492,1026074,893894,813672,135857,530080,946140,783409,629099,111423,57084,270723,279470,23062,60090,690348,362547,715025,974370,331303,196334,752679,652879,299565,237683,185272,210648,48315,615287,3426,831113,533353,863823,798400,768955,284860,536302,482495,675861,1021615,856413,30735,1034715,840428,735293,485253,427439,77733,75965,615831,207696,615899,93338,599607,19359,666796,366267,236611,28768,401794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]