SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042341 LIMIT 1 [ RunTime:0.001225s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042341 [ RunTime:0.003331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571021,526860,94748,595146,101869,468911,248831,612331,573006,171278,1026655,662578,151820,855252,1021991,705210,455710,955214,657730,362444,515841,117021,502626,440140,806065,460961,382959,708968,443364,320959,619095,863075,652708,511923,664544,564315,903704,1028789,472361,568359,187930,964800,871985,132518,755964,703084,310762,165380,73680,622080,209544,870140,14340,958815,208316,736453,82602,1027505,592600,83978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]