SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420521 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420521 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279909,344019,172839,994497,830562,847131,354266,900484,869687,681209,757321,350322,209632,870845,547694,354961,957418,359174,1041388,637540,388120,448799,438732,802578,922096,58793,761711,431440,776844,816863,265384,1034897,235115,749481,637061,346144,21919,1045633,585629,928626,99064,935189,311322,752679,971923,941746,189422,870491,64679,386539,728650,349884,249749,46617,421750,486890,695815,314397,784268,202495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]