SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319903 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319903 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733139,716531,167137,50713,949227,117363,774003,858392,509186,497565,756224,343793,155527,639041,623810,80215,954342,947230,553219,935549,1017254,305903,113892,997046,97206,397528,252479,574203,924293,594455,37073,490994,241307,155413,867683,310441,637392,469709,400113,906638,858095,344224,277538,449244,67138,288142,221839,790395,618337,706383,382578,773072,702162,875710,483853,402888,1040632,367769,834551,967193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001151s ]