SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201327 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201327 [ RunTime:0.003066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570714,930658,487306,137792,205979,373961,875123,622753,321295,905976,631560,518119,614630,210033,669395,690866,1027755,210859,644309,137228,642395,679814,840133,344096,515595,232351,46001,953615,717116,328739,584874,423576,81912,706538,205296,184987,370220,107654,737371,177140,730209,633201,411321,1042030,510772,699702,806855,753043,739785,299355,535944,1010845,524063,263806,544341,402652,220504,462208,973717,821949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]