SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590479 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590479 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370064,431238,660687,355983,756778,622010,192414,410418,430505,339659,753365,261676,59144,539380,212073,507860,648964,1015992,770405,12596,27781,919077,186361,153535,825903,373298,947255,265237,941661,617460,392354,590226,881837,508862,292033,1000897,704187,639035,254251,758290,334112,608593,669520,180809,324880,249225,869917,1029599,690598,487887,809124,246711,159995,15268,467627,310288,411952,523655,816209,7495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001636s ]