SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014303 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014303 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470689,240189,261669,611829,405064,255177,448385,127977,549885,89800,436281,185288,207103,319254,200848,51928,962882,386548,88416,1017547,310116,635689,219870,601758,977867,982995,124767,520200,377994,190630,333218,876684,689131,570261,159299,1014619,502873,607653,834127,960713,827733,956239,775612,416969,250153,462609,164942,556205,375316,309973,497821,682591,397092,592303,552149,865720,1037602,490543,300389,66211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]