SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 640804 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 640804 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613972,35512,752933,519757,481304,889802,766306,317881,376530,540471,642970,535114,520531,965612,425500,118365,573263,675401,201933,102528,1042963,922461,433752,714345,610823,1002457,326813,465122,614693,598521,643560,452332,17542,450240,108006,7526,931974,1005961,125380,816570,1003745,861690,957375,170032,410748,250897,136227,48974,401867,138928,130230,37642,993151,616736,680405,939647,337365,126330,700238,786956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 640804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 640804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]