SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457871 LIMIT 1 [ RunTime:0.000699s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457871 [ RunTime:0.003370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486731,1002941,995934,939041,442115,138183,331767,587132,236237,684377,588093,283379,756575,263832,89477,411651,852158,825691,1038127,398100,527900,909493,704790,675569,844726,53019,736753,245979,1043009,200527,840042,7848,933039,860621,597970,266707,585498,964977,211266,409387,723771,238721,1040596,446939,808087,948687,352751,758063,848883,474547,397248,466041,33489,1039327,766894,990468,1008189,241897,860807,339742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002307s ]