SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449881 LIMIT 1 [ RunTime:0.002087s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449881 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291812,821206,504253,856526,480094,717756,1030136,196329,621501,304081,178992,696157,313922,737964,78630,755565,509307,570304,62648,358632,112048,914234,853388,46859,738073,351450,935306,676291,1012723,114105,278161,470924,808671,673539,799888,170531,1009248,581337,327074,716861,974382,291201,965246,944038,753252,837907,1042089,358916,298310,706842,254835,959327,715302,741632,911626,467607,75436,404195,1023601,5331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]