SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410238 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410238 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714547,571044,987949,761105,603887,443352,143855,38194,434988,708457,199531,523306,162478,685529,301271,266511,129304,959002,765832,874693,875652,1028649,35146,194229,276344,783831,255537,414754,817922,849064,605009,260062,935154,148225,452125,378132,998101,537938,555156,51706,874373,329750,589483,138390,760733,363271,544955,564238,177502,774075,459647,291392,908776,859696,22027,138251,266032,943399,89206,757409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003334s ]