SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486211 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486211 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274949,983365,833506,632805,637553,818041,768118,872544,517535,794963,400452,1011127,514422,630499,555017,566944,363923,937100,462078,352053,145000,198185,675837,72926,1028037,244555,62262,573980,436435,13020,684504,318032,262401,724892,425113,98681,826283,254297,377764,277139,229160,624780,553968,108085,412037,239675,351618,313775,297207,651812,1037291,611742,599255,48941,804080,345116,198890,990403,1040370,551041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]