SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003727s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48618 LIMIT 1 [ RunTime:0.001881s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48618 [ RunTime:0.003556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334374,259991,312694,897126,1021298,363499,458883,847065,828614,431701,184111,570508,117767,1042196,218242,233031,1013545,224652,285507,967571,925034,961819,301262,238817,195498,283313,576175,655589,852954,384336,481184,861903,945291,146802,1022125,319822,104586,746104,589577,399649,493248,284121,702612,593815,192927,647489,1039391,48629,731334,719548,175623,401075,385957,284690,503163,452103,424331,113603,934587,505382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]