SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017463 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017463 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469271,622579,724300,574427,572934,958987,239367,945583,212530,947743,351433,288907,641301,702553,463273,88482,421326,618418,268714,29789,885162,112071,274656,386642,373510,776673,106102,866197,899672,700976,977775,322306,738984,435165,472507,135124,1019212,598900,256488,797880,1002470,6737,258917,923168,12230,530811,559443,449437,559264,103418,176739,541911,205088,195345,369861,653114,381700,745325,401811,947537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]