SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044028 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044028 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417047,695277,736838,125728,492632,85543,65039,470279,257172,218012,976711,150609,812457,219047,881737,202560,924016,961631,944429,884948,441331,520168,969627,534417,642410,486258,201937,511524,933043,344599,714553,197177,830008,718122,77750,338754,91744,395022,375117,644435,988167,175111,766242,73606,943204,48949,771136,222804,535277,812754,150131,279610,149383,998443,763722,903811,825342,934348,171905,218953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]