SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543618 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543618 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687893,106390,597002,624994,161918,346875,828990,853344,738780,219213,347989,151441,373896,915687,1031347,233033,736450,421441,69161,776394,699803,1016753,187260,619593,965457,373827,1030620,741091,490106,54028,51451,166943,165177,818983,709330,14369,356169,665449,559110,568070,352709,319154,923533,709255,1020469,334896,1007220,740385,144052,694644,9304,739809,1047713,211278,583276,77146,623809,183381,940857,881080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]