SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397448 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397448 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862853,654409,888702,924836,365111,1013911,387287,295112,485245,133070,109794,346073,687790,615072,154877,589483,880971,704711,824947,29035,326906,687860,781538,325577,1018961,80516,701571,417258,1033322,621746,854087,809687,362965,341867,637020,22966,36708,1043028,920399,431859,592293,201236,631300,359769,286483,823493,384790,840413,279582,64526,169146,568168,446055,481692,278198,475804,336515,994519,604847,45590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]