SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685243 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685243 [ RunTime:0.003018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143293,688295,373128,1045151,408613,282207,664154,475410,11074,399417,618359,196153,662974,666586,47035,392836,650814,859508,474070,629869,870501,698557,69119,1010997,11496,838903,134429,342475,466413,699708,804118,465987,933408,948559,1012807,69643,298272,151071,136346,115142,570582,105679,962961,690691,468941,716642,174329,975212,367034,355872,158376,799755,542054,1026745,24847,394028,37836,345376,1042490,994973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]