SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402830 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402830 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123814,930935,1021608,437981,648241,597600,634323,910083,480808,324592,343032,86437,751998,811093,288590,796900,92412,541682,810962,359982,483783,114140,399985,431783,64231,932573,829325,1433,250292,1022016,604818,446148,358331,461096,438533,861909,583163,871866,210087,311118,33023,378170,973722,561718,983319,458892,373805,646824,758698,513920,687485,790141,469806,997031,792265,37332,568458,195918,644240,147475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]