SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413682 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413682 [ RunTime:0.008287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337103,126769,424666,648216,481333,198510,270932,736488,361060,804000,812857,916260,789827,508341,189438,78002,718133,107539,655255,406744,427955,654499,1012606,1030431,214834,980760,40785,116185,241224,76410,1002623,918300,150075,1028693,861552,362491,269724,775539,706811,434029,327882,265974,886557,494034,457138,37838,907135,652219,1035339,899232,399464,1038877,1044134,104988,368434,589156,609528,771210,663878,860554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]