SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466078 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466078 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879430,100844,757076,654274,1039274,985940,452814,478486,161089,376853,280102,858255,772955,402541,548683,64236,519759,867655,487581,670321,502227,257549,656067,923743,783664,783183,711063,621217,51407,579752,496620,29351,47164,690521,54515,364829,94415,277229,50970,842416,90572,454687,312245,344486,64000,324035,883215,351569,407602,627778,644579,899697,184277,550644,402088,323417,277657,204214,417914,863530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]