SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508980 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508980 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202491,966860,528750,81362,219759,862783,520515,820367,986714,772837,540041,642477,1024281,713993,972429,578140,861642,322737,557811,183932,743193,347892,651049,650902,1018143,167338,501612,732951,62201,813901,225081,726306,994625,825223,918932,739647,430361,413180,771373,968258,925546,483215,830422,884216,125309,505626,870639,451130,807599,243807,1034741,903273,648555,526056,983385,837381,963740,560058,66029,168163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]