SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104160 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104160 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304267,56268,819511,289257,1033029,1043613,415559,360692,275806,639811,508862,64031,109515,507391,113785,908990,726844,354313,684047,516872,508417,766951,436215,40389,1042587,781677,443138,1015638,2312,500410,779642,248739,504954,513334,1008222,980663,458994,637992,705650,56140,110440,279280,647585,571057,8000,869504,28853,977433,566954,854028,776348,1005216,712103,154846,646758,564776,575165,785566,493566,885730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]