SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472909 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472909 [ RunTime:0.002780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014128,127420,681630,727847,46888,789767,236289,588462,734559,776942,944403,188367,922500,724406,172136,607230,359730,156828,192494,720424,625914,984203,988953,698300,469922,195106,206635,83205,943334,531119,638294,1013604,750347,123551,764041,340488,227896,877359,469787,286178,295290,989232,961167,706205,581105,669910,418811,224520,88514,334250,358627,955612,267023,341118,737166,842330,880890,698258,378689,726249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]