SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509530 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509530 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435576,54070,476998,954538,176599,487753,1026920,855394,534132,362535,745368,45064,900214,1012475,400315,941805,454751,423211,199641,52514,437427,208065,887072,565586,838609,205206,717236,504455,185785,937281,426514,315255,566779,919608,927505,518282,36435,311234,985776,372334,142140,894987,103800,564314,584706,318317,297965,664469,53526,636172,738196,401280,715597,682294,964609,340315,242791,585276,306220,1015596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]