SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48400 LIMIT 1 [ RunTime:0.000706s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48400 [ RunTime:0.002568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540390,246621,513878,876014,377249,36893,598253,813368,134586,332150,44635,602006,939957,733646,805812,718125,958948,493308,298353,248004,386130,633510,186418,902072,81168,283001,52936,998346,1040834,578156,546400,988436,561741,248220,382232,900867,903189,953881,1041092,733310,698277,653216,388694,857463,437635,88905,496142,99140,674845,154480,928094,1006194,685244,561237,482785,492490,581456,836747,310943,985882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]