SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000400 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000400 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246925,1028805,798010,416922,888439,533348,731522,770349,671586,683848,388446,423323,474949,377097,476592,456197,431297,534300,954992,340090,323127,1004202,300080,175475,854223,404672,708368,635228,942035,633131,151616,125659,637936,311905,794260,159752,614278,264270,808834,953156,637332,756915,160643,176148,242445,41910,550728,185174,58799,227505,925303,740542,689667,798309,477580,819589,216749,25267,572909,63157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]