SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347813 LIMIT 1 [ RunTime:0.000986s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347813 [ RunTime:0.003123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534669,303542,969861,301463,253891,606677,12472,903642,700780,478317,936813,70905,486958,528561,225510,889613,168224,214040,865220,499202,331972,368461,146948,932060,832344,251332,320774,318447,939294,105418,129589,134324,396395,305786,893285,1043591,141810,59045,796913,901581,312149,358185,980041,578893,444239,515951,315689,146498,49819,103196,626797,126190,461758,212729,663663,908305,684401,941954,144330,465498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]