SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045424 LIMIT 1 [ RunTime:0.002484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045424 [ RunTime:0.008027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422919,330198,808435,559625,718708,288292,67658,305098,810917,83717,241293,987752,253726,824522,33893,465989,373443,286098,128532,14762,972796,560397,829860,261057,248870,923534,248053,530568,775571,526208,1005227,692810,94806,252538,808419,779172,696574,844026,654849,607715,217186,656814,993492,957569,335216,848029,702784,650282,143544,195308,56210,249590,906228,315543,76042,626742,724724,708487,906102,699532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003021s ]