SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241218 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241218 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035222,600967,171993,862884,922290,524642,486584,52323,113080,462378,914574,921605,163381,673560,922390,595853,150942,716200,313066,268049,427271,683947,260774,835136,353112,116846,641511,412844,799293,311898,159718,786925,800297,129308,432501,348961,735770,738885,216235,1046360,296991,870067,407027,1048444,103774,472945,785035,38459,503172,47866,669395,739104,690590,421058,1024078,476689,564436,810884,260825,19761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]