SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198414 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198414 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205914,714084,444210,1014554,996598,193073,459810,281609,158231,584390,953291,663252,14529,538492,456551,203650,370425,113590,951235,534149,513428,82272,240398,105758,122139,248185,474751,919637,749083,216764,722204,322070,382342,676367,1026269,717918,519432,1019976,629951,621201,763810,870210,477993,788032,934943,235787,423119,610248,706133,146264,1021300,106019,76703,264758,578028,525462,961375,485964,162617,21226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001425s ]