SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026050 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026050 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721043,276041,950056,1008053,502847,187983,443313,846650,595375,935748,239597,621656,398782,607343,757422,642540,62166,229353,14775,964953,993447,175476,325344,831477,816125,638246,695370,838981,410872,399605,794711,86723,622520,184833,148810,254139,582845,394608,791116,888641,669957,700242,286259,768356,211339,635367,714816,618811,429751,566099,246987,322255,86579,199055,832170,463041,822761,399235,798779,105322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]