SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041234 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041234 [ RunTime:0.004145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551838,172698,109972,388289,470146,958564,919321,285793,795986,28108,479351,581282,934283,92781,42786,478509,813457,979662,566149,228990,677741,975532,828308,741338,443057,146178,386977,1025183,647622,48249,73449,224873,178709,860959,571100,38805,919011,427202,257375,682303,418256,452204,223047,624383,507094,707967,1018312,389729,762640,598891,173144,907160,1038260,675145,836340,29185,174609,804894,756035,750932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]